/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80028 (8.0.28)
 Source Host           : localhost:3306
 Source Schema         : book

 Target Server Type    : MySQL
 Target Server Version : 80028 (8.0.28)
 File Encoding         : 65001

 Date: 07/08/2025 16:56:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `book_id` int NOT NULL AUTO_INCREMENT COMMENT '图书ID',
  `book_name` varchar(255) NOT NULL COMMENT '图书名称',
  `author_name` varchar(255) NOT NULL COMMENT '图书作者',
  `price` double(12,2) DEFAULT '0.00' COMMENT '图书价格',
  `category_id` int NOT NULL COMMENT '分类ID,关联分类表主键',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int DEFAULT '1' COMMENT '是否上架 1:上架 0:下架',
  `book_url` varchar(255) DEFAULT NULL COMMENT '图书主图地址',
  `book_address` varchar(255) DEFAULT NULL COMMENT '真实地址',
  PRIMARY KEY (`book_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `book_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10109 DEFAULT CHARSET=utf8mb3 COMMENT='图书表';

-- ----------------------------
-- Records of book
-- ----------------------------
BEGIN;
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10015, '平凡的世界', '路遥', 100.12, 10003, '2025-08-02 23:44:45', 1, 'http://www.baidu.com14.png', '/Users/Michael/Document');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10016, '测试图书名称15', '图书作者15', 50.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com15.png', '/Users/michael/Downloads/15.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10017, '测试图书名称16', '图书作者16', 51.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com16.png', '/Users/michael/Downloads/16.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10018, '测试图书名称17', '图书作者17', 52.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com17.png', '/Users/michael/Downloads/17.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10019, '测试图书名称18', '图书作者18', 53.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com18.png', '/Users/michael/Downloads/18.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10020, '测试图书名称19', '图书作者19', 54.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com19.png', '/Users/michael/Downloads/19.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10021, '测试图书名称20', '图书作者20', 55.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com20.png', '/Users/michael/Downloads/20.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10022, '测试图书名称21', '图书作者21', 56.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com21.png', '/Users/michael/Downloads/21.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10023, '测试图书名称22', '图书作者22', 57.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com22.png', '/Users/michael/Downloads/22.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10024, '测试图书名称23', '图书作者23', 58.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com23.png', '/Users/michael/Downloads/23.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10025, '测试图书名称24', '图书作者24', 59.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com24.png', '/Users/michael/Downloads/24.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10026, '测试图书名称25', '图书作者25', 60.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com25.png', '/Users/michael/Downloads/25.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10027, '测试图书名称26', '图书作者26', 61.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com26.png', '/Users/michael/Downloads/26.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10028, '测试图书名称27', '图书作者27', 62.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com27.png', '/Users/michael/Downloads/27.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10029, '测试图书名称28', '图书作者28', 63.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com28.png', '/Users/michael/Downloads/28.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10030, '测试图书名称29', '图书作者29', 64.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com29.png', '/Users/michael/Downloads/29.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10031, '测试图书名称30', '图书作者30', 65.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com30.png', '/Users/michael/Downloads/30.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10032, '测试图书名称31', '图书作者31', 66.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com31.png', '/Users/michael/Downloads/31.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10033, '测试图书名称32', '图书作者32', 67.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com32.png', '/Users/michael/Downloads/32.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10034, '测试图书名称33', '图书作者33', 68.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com33.png', '/Users/michael/Downloads/33.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10035, '测试图书名称34', '图书作者34', 69.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com34.png', '/Users/michael/Downloads/34.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10036, '测试图书名称35', '图书作者35', 70.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com35.png', '/Users/michael/Downloads/35.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10037, '测试图书名称36', '图书作者36', 71.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com36.png', '/Users/michael/Downloads/36.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10038, '测试图书名称37', '图书作者37', 72.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com37.png', '/Users/michael/Downloads/37.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10039, '测试图书名称38', '图书作者38', 73.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com38.png', '/Users/michael/Downloads/38.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10040, '测试图书名称39', '图书作者39', 74.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com39.png', '/Users/michael/Downloads/39.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10041, '测试图书名称40', '图书作者40', 75.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com40.png', '/Users/michael/Downloads/40.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10042, '测试图书名称41', '图书作者41', 76.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com41.png', '/Users/michael/Downloads/41.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10043, '测试图书名称42', '图书作者42', 77.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com42.png', '/Users/michael/Downloads/42.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10044, '测试图书名称43', '图书作者43', 78.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com43.png', '/Users/michael/Downloads/43.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10045, '测试图书名称44', '图书作者44', 79.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com44.png', '/Users/michael/Downloads/44.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10046, '测试图书名称45', '图书作者45', 80.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com45.png', '/Users/michael/Downloads/45.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10047, '测试图书名称46', '图书作者46', 81.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com46.png', '/Users/michael/Downloads/46.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10048, '测试图书名称47', '图书作者47', 82.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com47.png', '/Users/michael/Downloads/47.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10049, '测试图书名称48', '图书作者48', 83.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com48.png', '/Users/michael/Downloads/48.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10050, '测试图书名称49', '图书作者49', 84.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com49.png', '/Users/michael/Downloads/49.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10051, '测试图书名称50', '图书作者50', 85.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com50.png', '/Users/michael/Downloads/50.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10052, '测试图书名称51', '图书作者51', 86.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com51.png', '/Users/michael/Downloads/51.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10053, '测试图书名称52', '图书作者52', 87.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com52.png', '/Users/michael/Downloads/52.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10054, '测试图书名称53', '图书作者53', 88.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com53.png', '/Users/michael/Downloads/53.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10055, '测试图书名称54', '图书作者54', 89.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com54.png', '/Users/michael/Downloads/54.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10056, '测试图书名称55', '图书作者55', 90.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com55.png', '/Users/michael/Downloads/55.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10057, '测试图书名称56', '图书作者56', 91.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com56.png', '/Users/michael/Downloads/56.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10058, '测试图书名称57', '图书作者57', 92.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com57.png', '/Users/michael/Downloads/57.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10059, '测试图书名称58', '图书作者58', 93.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com58.png', '/Users/michael/Downloads/58.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10060, '测试图书名称59', '图书作者59', 94.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com59.png', '/Users/michael/Downloads/59.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10061, '测试图书名称60', '图书作者60', 95.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com60.png', '/Users/michael/Downloads/60.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10062, '测试图书名称61', '图书作者61', 96.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com61.png', '/Users/michael/Downloads/61.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10063, '测试图书名称62', '图书作者62', 97.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com62.png', '/Users/michael/Downloads/62.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10064, '测试图书名称63', '图书作者63', 98.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com63.png', '/Users/michael/Downloads/63.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10065, '测试图书名称64', '图书作者64', 99.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com64.png', '/Users/michael/Downloads/64.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10066, '测试图书名称65', '图书作者65', 100.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com65.png', '/Users/michael/Downloads/65.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10067, '测试图书名称66', '图书作者66', 101.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com66.png', '/Users/michael/Downloads/66.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10068, '测试图书名称67', '图书作者67', 102.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com67.png', '/Users/michael/Downloads/67.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10069, '测试图书名称68', '图书作者68', 103.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com68.png', '/Users/michael/Downloads/68.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10070, '测试图书名称69', '图书作者69', 104.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com69.png', '/Users/michael/Downloads/69.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10071, '测试图书名称70', '图书作者70', 105.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com70.png', '/Users/michael/Downloads/70.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10072, '测试图书名称71', '图书作者71', 106.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com71.png', '/Users/michael/Downloads/71.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10073, '测试图书名称72', '图书作者72', 107.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com72.png', '/Users/michael/Downloads/72.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10074, '测试图书名称73', '图书作者73', 108.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com73.png', '/Users/michael/Downloads/73.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10075, '测试图书名称74', '图书作者74', 109.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com74.png', '/Users/michael/Downloads/74.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10076, '测试图书名称75', '图书作者75', 110.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com75.png', '/Users/michael/Downloads/75.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10077, '测试图书名称76', '图书作者76', 111.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com76.png', '/Users/michael/Downloads/76.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10078, '测试图书名称77', '图书作者77', 112.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com77.png', '/Users/michael/Downloads/77.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10079, '测试图书名称78', '图书作者78', 113.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com78.png', '/Users/michael/Downloads/78.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10080, '测试图书名称79', '图书作者79', 114.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com79.png', '/Users/michael/Downloads/79.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10081, '测试图书名称80', '图书作者80', 115.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com80.png', '/Users/michael/Downloads/80.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10082, '测试图书名称81', '图书作者81', 116.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com81.png', '/Users/michael/Downloads/81.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10083, '测试图书名称82', '图书作者82', 117.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com82.png', '/Users/michael/Downloads/82.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10084, '测试图书名称83', '图书作者83', 118.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com83.png', '/Users/michael/Downloads/83.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10085, '测试图书名称84', '图书作者84', 119.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com84.png', '/Users/michael/Downloads/84.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10086, '测试图书名称85', '图书作者85', 120.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com85.png', '/Users/michael/Downloads/85.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10087, '测试图书名称86', '图书作者86', 121.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com86.png', '/Users/michael/Downloads/86.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10088, '测试图书名称87', '图书作者87', 122.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com87.png', '/Users/michael/Downloads/87.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10089, '测试图书名称88', '图书作者88', 123.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com88.png', '/Users/michael/Downloads/88.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10090, '测试图书名称89', '图书作者89', 124.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com89.png', '/Users/michael/Downloads/89.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10091, '测试图书名称90', '图书作者90', 125.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com90.png', '/Users/michael/Downloads/90.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10092, '测试图书名称91', '图书作者91', 126.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com91.png', '/Users/michael/Downloads/91.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10093, '测试图书名称92', '图书作者92', 127.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com92.png', '/Users/michael/Downloads/92.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10094, '测试图书名称93', '图书作者93', 128.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com93.png', '/Users/michael/Downloads/93.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10095, '测试图书名称94', '图书作者94', 129.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com94.png', '/Users/michael/Downloads/94.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10096, '测试图书名称95', '图书作者95', 130.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com95.png', '/Users/michael/Downloads/95.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10097, '测试图书名称96', '图书作者96', 131.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com96.png', '/Users/michael/Downloads/96.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10098, '测试图书名称97', '图书作者97', 132.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com97.png', '/Users/michael/Downloads/97.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10099, '测试图书名称98', '图书作者98', 133.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com98.png', '/Users/michael/Downloads/98.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10100, '测试图书名称99', '图书作者99', 134.80, 10001, '2025-08-02 12:46:39', 1, 'http://www.baidu.com99.png', '/Users/michael/Downloads/99.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10103, '666', '66', 66.00, 10001, '2028-05-05 14:41:05', 1, '/pic/9955b36d-e4f1-4d0f-9370-71f7a568d228.png', '/private/var/folders/b1/mk40drvx2d71vh8xc950nw8w0000gn/T/tomcat-docbase.8080.4538352251397974390/pic/9955b36d-e4f1-4d0f-9370-71f7a568d228.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10104, '笑傲江湖', '仗剑天涯', 36.00, 10001, '2024-12-05 21:00:09', 0, '/pic/6a8f274d-2601-4fe5-b23c-4600f3d2a4cf.png', '/private/var/folders/b1/mk40drvx2d71vh8xc950nw8w0000gn/T/tomcat-docbase.8080.7433341353548131395/pic/6a8f274d-2601-4fe5-b23c-4600f3d2a4cf.png');
INSERT INTO `book` (`book_id`, `book_name`, `author_name`, `price`, `category_id`, `create_time`, `status`, `book_url`, `book_address`) VALUES (10108, '河北城建', '99', 99.00, 10000, '2026-04-05 20:16:37', 1, '/pic/0f24488b-0e1b-4af4-a7cc-82a8fd3ae5d7.png', '/private/var/folders/b1/mk40drvx2d71vh8xc950nw8w0000gn/T/tomcat-docbase.8080.8183279888643021355/pic/0f24488b-0e1b-4af4-a7cc-82a8fd3ae5d7.png');
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `category_id` int NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `category_name` varchar(255) NOT NULL COMMENT '分类名称',
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10004 DEFAULT CHARSET=utf8mb3 COMMENT='图书分类表';

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`category_id`, `category_name`) VALUES (10000, '科技');
INSERT INTO `category` (`category_id`, `category_name`) VALUES (10001, '文学');
INSERT INTO `category` (`category_id`, `category_name`) VALUES (10002, '历史');
INSERT INTO `category` (`category_id`, `category_name`) VALUES (10003, '财经');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
